package com.xja.dao;

import com.xja.entity.Indent;
import com.xja.entity.Room;
import com.xja.entity.pojo.BillsAndRoom;
import com.xja.entity.pojo.UrByIndent;

import java.sql.SQLException;
import java.util.List;

/**
 * @author zcy
 * @create 2022-05-05 19:50
 */
public interface ZcyDao {
    public List<Room> findRoom() throws SQLException;

    public Integer addRoom(Room room) throws SQLException;

    Room findRoomById(int updateId) throws SQLException;

    Integer updateRoom(Room updateroom) throws SQLException;

    Integer deleteRoomById(int deleteId) throws SQLException;

    List<UrByIndent> FindAllIndent() throws SQLException;

    Integer deleteIndentById(int deleteIndentById) throws SQLException;

    Integer updateIndent(Indent updateIndent) throws SQLException;

    Integer updateStatusById(Integer roomId, Integer status) throws SQLException;

    List<BillsAndRoom> findBroom()throws SQLException;
}
